SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE FUNCTION dbo.fnConcat (@input sql_variant)
RETURNS VARCHAR(100)
WITH EXECUTE AS CALLER
AS
-- place the body of the function here
BEGIN
     RETURN(CONVERT(VARCHAR(100), @input))
END
GO
EXEC sp_addextendedproperty N'VirtualFolder', N'Generic', 'SCHEMA', N'dbo', 'FUNCTION', N'fnConcat', NULL, NULL
GO
